package com.fowo.api.model.requisition.product;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.fowo.api.common.excel.ImageConvert;
import com.fowo.api.sys.entity.SysFile;
import java.util.List;
import javax.validation.constraints.*;
import lombok.Data;

/** 调拨单子表 导入导出辅助模型 */
@Data
public class RequisitionProductExcelPo {

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "所属调拨单")
  private String parentRequisitionRqtSn;

  @ExcelIgnore
  @ExcelProperty(value = "所属调拨单")
  private Long parentRequisition;

  @ExcelProperty(value = "图片", converter = ImageConvert.class)
  private List<SysFile> img;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "库存表")
  private String cashStatementBatchNo;

  @ExcelIgnore
  @ExcelProperty(value = "库存表")
  private Long cashStatement;

  @Size(max = 50, message = "品名长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "品名")
  private String productId;

  @Size(max = 50, message = "SKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "SKU")
  private String sku;

  @Size(max = 50, message = "产品标签长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "产品标签")
  private String productLabel;

  @Size(max = 50, message = "FNSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "FNSKU")
  private String fnsku;

  @Size(max = 50, message = "店铺长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "店铺")
  private String shopName;

  @ExcelProperty(value = "可用量")
  private Long availbleNum;

  @ExcelProperty(value = "可用调拨量")
  private Long availbleRqtNum;

  @ExcelProperty(value = "次品量")
  private Long defectiveQuantity;

  @ExcelProperty(value = "次品调拨量")
  private Long defectiveRqtQuantity;

  @ExcelProperty(value = "单品重量(g)")
  private java.math.BigDecimal basisWeight;

  @ExcelProperty(value = "包装规格(cm)")
  private java.math.BigDecimal packingSpecification;

  @Size(max = 50, message = "备注长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "备注")
  private String remark;
}
